/**
 * Created with IntelliJ IDEA.
 * Description:
 * User: 17655
 * Date: 2025-05-15
 * Time: 19:59
 */
public class test52 {
    /**
     * 众安保险的联表查询
     */

    /*
    SELECT
    ci.category,
    ROUND(SUM(TIMESTAMPDIFF(MINUTE, pr.start_time, pr.end_time)), 2) AS total_watch_time_minutes,
    ROUND(AVG(pr.rating), 3) AS average_rating
    FROM
    play_record_tb pr
    JOIN
    course_info_tb ci ON pr.course_id = ci.course_id
    GROUP BY
    ci.category
    ORDER BY
    ci.category ASC;
    */
}
